UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q9ZzEqJRxOs0eVdQEvqokiOuEDQeRgoylbUEaJy5cPg='
WHERE
key_id = '24a9c781a7e8b213e858826ff35c71ca81b3513b6adae53334652b6bf3174f04'
AND (
token = 'Q9ZzEqJRxOs0eVdQEvqokiOuEDQeRgoylbUEaJy5cPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)