UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2W4s6zLnfJf1X4TzB5V9/KKgUiwpTuVhToT0vnhRFaA='
WHERE
key_id = '318e25be372ba5328b80379a95ee740ef3111adaf17c8dbc105b299fabc6960d'
AND (
token = '2W4s6zLnfJf1X4TzB5V9/KKgUiwpTuVhToT0vnhRFaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)