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