UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XF00VvYnNsIQOB+SRvPaulGjN/ZY3DM6GLK0y8tuM+Q='
WHERE
key_id = 'ed34e5f2c08be0adb509611423f58edca2c592c57534755091d8aa3229a74151'
AND (
token = 'XF00VvYnNsIQOB+SRvPaulGjN/ZY3DM6GLK0y8tuM+Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)