UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TMhnqVKV/tw3LHG4cFD4drGmTRtW/fStO74oAJThMCI=' 
WHERE 
  key_id = '19d9b75012f1a2c8f3913191c25dca7283c4ccecc8044b64796f0142ef8141c7' 
  AND (
    token = 'TMhnqVKV/tw3LHG4cFD4drGmTRtW/fStO74oAJThMCI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00098