UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N1GG+RaBIDmKJ1L9HW6czo14KTfMjZcTazPJohMJo0U='
WHERE
key_id = 'eb1eafd260eda331673bd91a5a61624608053f86ca84a7e996309ad7bd85ec30'
AND (
token = 'N1GG+RaBIDmKJ1L9HW6czo14KTfMjZcTazPJohMJo0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)