UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Bx7Yj8xzD1iRU1cWryYzbseMIoPCOv17BMF08BVDrCg='
WHERE
key_id = '2f7b2308b719c3add2321229f9c6c0ec8aebc6e6b0572834a3db2e9b0e7ac2b1'
AND (
token = 'Bx7Yj8xzD1iRU1cWryYzbseMIoPCOv17BMF08BVDrCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)