UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'vJiCMOwMTsOGcLNr/vf9C+KrQbOb/1Ua8Vfx8Ruotl0=' 
WHERE 
  key_id = '86186cf9556592eb036c4466877eadf617210a43f32e006524c83c1bbd48674d' 
  AND (
    token = 'vJiCMOwMTsOGcLNr/vf9C+KrQbOb/1Ua8Vfx8Ruotl0=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048