UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xBmy4xP7hfKqDyi2E194/ZTAGCvh3WEFbc7v3YPoMbk='
WHERE
key_id = 'b27bec7725a92f598a00c9b5b107e7ed1f838b4acd4153af85ddf87dbe49a75e'
AND (
token = 'xBmy4xP7hfKqDyi2E194/ZTAGCvh3WEFbc7v3YPoMbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)