UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vy00IqwNdbLUQrxv5E58MjViNUHdPxNkgpDzS5eHbnw='
WHERE
key_id = '6dfe7f5ab05c41b6f6f481adfda937b3120a05df72a560339eb65fd57fae9890'
AND (
token = 'Vy00IqwNdbLUQrxv5E58MjViNUHdPxNkgpDzS5eHbnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)