UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v5mps7YsIwJfGquGIT/KexPnqn73lH+1JUt0tpdeUz4='
WHERE
key_id = 'd9d3bd37130283110f146c689a707018b5e86017ad80f8c333536f22814c978a'
AND (
token = 'v5mps7YsIwJfGquGIT/KexPnqn73lH+1JUt0tpdeUz4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)