UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3KXWGyUtdhfDeQl0kM8oL22QD2UiMQiOqCwhoxRc3CU='
WHERE
key_id = '0df985da39f7f6d9f744b818133fee31433405ca0f777b0d72cfd2d8a05df927'
AND (
token = '3KXWGyUtdhfDeQl0kM8oL22QD2UiMQiOqCwhoxRc3CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)