UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eaosS6iSjcdHxEvrZIq9KSJNcxkySjwJYp/diwEE9yA='
WHERE
key_id = '9fb8d1845bf2da1a9051f9fa1dc2d018a0b59a5a762f22654a92e1d42f20f8c2'
AND (
token = 'eaosS6iSjcdHxEvrZIq9KSJNcxkySjwJYp/diwEE9yA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)