UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kYY4Q6P6VpVZ3HlQaS7816Nr7aW3lWhYS7k7cAcPm28='
WHERE
key_id = 'bf4aacea4fbaea902d980e920f7b246e56b5cc904e6fe3041e4b5aeb320f01b6'
AND (
token = 'kYY4Q6P6VpVZ3HlQaS7816Nr7aW3lWhYS7k7cAcPm28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)