UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cl/RPYcUelSneDHcS/7hVDnlxmNOJlCbXyXR/J2lgp0='
WHERE
key_id = 'a7c5d75b7907e343189812da9337486abfef4f7e9d3068398a96312b28c36f54'
AND (
token = 'cl/RPYcUelSneDHcS/7hVDnlxmNOJlCbXyXR/J2lgp0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)