UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29hsy7V87OT3uJLgZJmEaC7cd4NptiJjH6EkeE0XZuw='
WHERE
key_id = 'a92fc7945b07b57c695a2993af7f6c7b1bbff586e3b5a42747d9a9390538a9ac'
AND (
token = '29hsy7V87OT3uJLgZJmEaC7cd4NptiJjH6EkeE0XZuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)