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