UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WmREAtHJz5ZG4RKRd0tWvhd/kAVZEmSC0yMLi+GTMfU='
WHERE
key_id = '73e867ecb338975a1e9ffe671927e4f4cad7448898a88d589f746a7ee8648e64'
AND (
token = 'WmREAtHJz5ZG4RKRd0tWvhd/kAVZEmSC0yMLi+GTMfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)