UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lczfWB5loXvNmvDmkMHsZTCGhpB0IB7GTcMuxJUNL/4='
WHERE
key_id = 'f9b27510ed5e8731fad89c331fd41e4226fbd32f0cf99242ece21a3fa1180258'
AND (
token = 'lczfWB5loXvNmvDmkMHsZTCGhpB0IB7GTcMuxJUNL/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)