UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+aw90upcaVN5gjEjYs9lYCIfCtPo7sWFfLAYtn86Smo=' 
WHERE 
  key_id = '401a098b0d8e79a31002f3cf2bb915cb2c0b40ea4bbf77f1342d42ebba8878f1' 
  AND (
    token = '+aw90upcaVN5gjEjYs9lYCIfCtPo7sWFfLAYtn86Smo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030