UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'unlzFrhgnVr8D2imtgmDt/oBPVnf3PV0cBPDVgJrbGo=' 
WHERE 
  key_id = 'e4339de3c0dc0da0d47dadc276aa630be9f80ddf9e4e6b6232f27d025d786819' 
  AND (
    token = 'unlzFrhgnVr8D2imtgmDt/oBPVnf3PV0cBPDVgJrbGo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036