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