UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FzD9KSUYOh+7R+N+B3RUjLrythiLk7i9KT6L8Zw29i8='
WHERE
key_id = 'a6c6600619c21453587c698a8055dab147f59d55a51a82a04611a6a027f8288e'
AND (
token = 'FzD9KSUYOh+7R+N+B3RUjLrythiLk7i9KT6L8Zw29i8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)