UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'eYjl353niEblpcXXYs/3xfweoT1zMESxi3ng2mAhaD4=' 
WHERE 
  key_id = '24b6336f75001af0e4060375561bdd357627421e2a34166b5abe3c93d1d924d3' 
  AND (
    token = 'eYjl353niEblpcXXYs/3xfweoT1zMESxi3ng2mAhaD4=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023