UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'acHRwfEiSLw3QD5qyv4voFnQikvmWxjJxvdFRbO9h88='
WHERE
key_id = '585699f493cae89d4dfcc178c32eef47dba38b3b83eeee75a1c8bb77895e7e52'
AND (
token = 'acHRwfEiSLw3QD5qyv4voFnQikvmWxjJxvdFRbO9h88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)