UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NMQQi+aILQ3Z5kaT237ks+XJiILdnnyjyfMGu9jBx2g='
WHERE
key_id = 'b8c61916b737ce35e7f1a13acba48ec5dc5fd623bd0505f48183778781987263'
AND (
token = 'NMQQi+aILQ3Z5kaT237ks+XJiILdnnyjyfMGu9jBx2g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)