UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zXKUOp17g4dWWlSbpRNK4zCFwOfSmEiLsQV3AbwjXEw='
WHERE
key_id = 'b27c0e93b7d0ac898c79ed52ff044fc7331c50a79601b34c8d873f001b33029e'
AND (
token = 'zXKUOp17g4dWWlSbpRNK4zCFwOfSmEiLsQV3AbwjXEw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)