UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cj7BTQi8o1OMlgTR//QtyybRWWigkO/BtyYAcMJAJ7c='
WHERE
key_id = 'f3699464182e14d618c7e6e9c3ad002df72bbd9f191d2ebe2aedef5fa5fcbb2a'
AND (
token = 'cj7BTQi8o1OMlgTR//QtyybRWWigkO/BtyYAcMJAJ7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)