UPDATE cscart_lock_keys SET expiry_at = UNIX_TIMESTAMP(NOW()) + 30, token = 'exP974OBo8G8AnzeNvisAYCDrOp511ts8mJmkCOGvY4=' WHERE key_id = 'a78b7c637a7d13c37b211e376bd614d348e35d4984345581b6149dc6150e3de0' AND (token = 'exP974OBo8G8AnzeNvisAYCDrOp511ts8mJmkCOGvY4=' OR expiry_at <= UNIX_TIMESTAMP(NOW()))