UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCw3wKq+j3UBvDfa8NS7UrUM9B8XP4M/OZA1o2bl/8c='
WHERE
key_id = '78378d39f88e073ac5336e272f65f71374023309faef75b55ef4c30e5d3acb99'
AND (
token = 'ZCw3wKq+j3UBvDfa8NS7UrUM9B8XP4M/OZA1o2bl/8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)