UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JXBlx0BNu8GPKBcWBiM9U8Sd4qud5jfts1m+sP7MNk8='
WHERE
key_id = '64d847490f5a9c32bbf474e22fe8a9bdd35414b9d13ccc1f95e311bc538def0c'
AND (
token = 'JXBlx0BNu8GPKBcWBiM9U8Sd4qud5jfts1m+sP7MNk8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)